JSON decoder plugin

Use the JSON decoder plugin to automatically parse a column containing JSON objects. The objects are broken into named fields and are discarded if they lack certain fields or contain forbidden ones.

Many sources of data use JSON (Java Script Object Notation) as a way of encoding their data. There are a number of tools in Kettle that can be used to read and parse JSON, but all of them require extensive configuration which is tedious and error prone.

This transform step is used to automatically parse a column containing JSON objects. The objects are broken into named fields. Specific JSON objects are discarded when they lack certain fields or have forbidden ones in them.

The plugin in this directory must be added to a script that runs in an open-source ETL package called Kettle. There are three ways of running the scripts:

1. With a user interface, using a Kettle application called 'Spoon'. Spoon allows you to edit and debug the scripts.
2. From a command line, using a Kettle application called 'Kitchen'.
3. From another Kettle script using the 'Job' step.

• Steps
  • AMQP Kettle Step Plugin
  • Execute Documents Plugin
  • JSON Decoder Plugin
    • Using the JSON Decoder Plugin
  • OData Plugin
  • Raise Event plugin
  • Select Documents Plugin
  • Sentiment Score Plugin
  • Twitter Plugin